package com.shzq.dao;

import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

import java.util.List;
import java.util.Map;

@Component
public interface PointMapper {
    @Select("Select latitude,id from earthquake")
    List<Map<String,String>> findAllLatitude();

    @Select("select latitude from earthquake where depth >= #{begin} and depth <#{end}")
    List<String> findByDepth(Map<String,Integer> map);

    @Select("select latitude from earthquake where depth >= #{begin}")
    List<String> findMoreThanDepth(int begin);

    @Select("select latitude from earthquake where strength >=#{begin} and strength<#{end}")
    List<String>findByStrength(Map<String,Integer> map);

    @Select("select latitude from earthquake where strength >#{begin}")
    List<String>findMoreThanStrength(int begin);

    @Select("select latitude from earthquake where strength <=#{end}")
    List<String>findLessThanStrength(int end);
}
